package com.tarena.lbs.content.dao.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.tarena.lbs.content.pojo.po.ArticleSearchPO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface ArticleMapper extends BaseMapper<ArticleSearchPO> {
    
    /**
     * 获取所有不重复的文章标签
     * @return 文章标签列表
     */
    @Select("SELECT DISTINCT article_label FROM article_search WHERE article_label IS NOT NULL AND article_label != ''")
    List<String> selectAllArticleLabels();
}